`:top

In `F33f`_`[relational databases`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Relational_databases]`_`f, a `!nested table`! is a `F33f`_`[table`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Table_(database)]`_`f that is embedded within another table.

Individual elements can be inserted, updated, and deleted in a nested table. Since individual `F33f`_`[elements`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Element_(mathematics)]`_`f can be modified in a nested table, they are more flexible than an `F33f`_`[array`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Array_data_structure]`_`f because elements in an array can only be modified as a whole, not individually.

A nested table doesn't have a maximum size, and an arbitrary number of elements can be stored in it.

>>External links

• "Nested Tables (Analysis Services - Data Mining)". `*Microsoft`*. May 7, 2018.

• "PL/SQL Collections and Records: Nested Tables". `*Oracle Database Online Documentation Library, 12c Release 1 (12.1.0.2)`*. 2017.

• "Oracle Collections: A Definition in Plain English Part 2". Archived from the original on July 1, 2006.

• "Oracle Database 10g: SQL (Oracle Press)". Archived from the original on September 8, 2005.

`c`F0af`_`[↑ Back to top`#top]`_`f`a